home *** CD-ROM | disk | FTP | other *** search
/ Apple Reference & Presen…tion Library 1994 January / ARPL-Jan94-Disc1of2-Partner-Edition.iso / Stack Data / Presentation Maker / Slides / RDBMS Tech Pres.p / RDBMS Tech Pres.022 (.png) < prev    next >
Macintosh Picture Format  |  1993-12-08  |  10.8 KB  |  640x480  |  8-bit (35 colors)  |  [PICT/ppxi]
   ocr: Base and View Tables order nr cust 5050 nr ord $3456.98 amounti salesrep 300 office 302 Orders Tal 7485943 4738303 5030 $67000.00 400 302 4734842 5010 $50,000.00 300 105 6749403 5010 $8,750.46 1100 302 9483782 5450 $6,575.00 - 1300 T10 3847394 5600 $11,450.75 - 1500 220 CREATE VIEW Good Sales (CUST NR, ORD AMOUNTSALESREP) AS SELECT CUST NR, ORD AMOUNT, FROM Orders WHERE ORD AMOUNT A 10000 cust nr ord amount salesrep Good Sales Tableoso $67,000.00 $50,000.00 300 400 5600 $11,450.75 1500